-- Combining Result Sets
SELECT * FROM TestA
UNION ALL
SELECT * FROM TestB;



- Limiting Result Sets using TABLESAMPLE
SELECT FirstName, LastName
FROM Person.Person
TABLESAMPLE (10 PERCENT);



-- Limiting Result Sets using TOP
SELECT TOP(15) PERCENT ProductID
FROM Production.Product
ORDER BY ProductID;

